UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B9DAtXdX3opb4+UCGbwpWUAE6VmCE8VAwHR6+Swiuzk='
WHERE
key_id = 'bef3b9fbc648f06bf9033c354ee61f04b27712b97d4d5814261ed4242ef66b11'
AND (
token = 'B9DAtXdX3opb4+UCGbwpWUAE6VmCE8VAwHR6+Swiuzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)