UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qEr/oJP5XXv5aNpbVmckJ3GHzYKeVVokD31bN2z+uqI='
WHERE
key_id = 'a9038feb16a4ad05c53fe7c7fa4d4d8d3dc4dcf39b327ec462df0f8b03749904'
AND (
token = 'qEr/oJP5XXv5aNpbVmckJ3GHzYKeVVokD31bN2z+uqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)