UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jgLuKJaIc0mSzAhsPLF0Xw5Z+RUccVeD0JpcZuLSYFc='
WHERE
key_id = 'af55c8ad5d15cb7ce987991fe2fb594aaf69c91bf04366140a001544baf6beb0'
AND (
token = 'jgLuKJaIc0mSzAhsPLF0Xw5Z+RUccVeD0JpcZuLSYFc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)