UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'krwGTsSHxOH7tIsXQYFj+CMIZqC2a8us1imBndnwHnI='
WHERE
key_id = '1bdad1ed57ce737e05c260271c5079cf98aa83034f6aee9fe3866a03a318e8fe'
AND (
token = 'krwGTsSHxOH7tIsXQYFj+CMIZqC2a8us1imBndnwHnI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)