UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cBU8PNZfSza6jKT6R5XzMkj4Aoni1aB0O9nN1aruj10='
WHERE
key_id = 'fc319b600452773dff08b71459f6d9465be3f677a4d1d9f4402935a19058203b'
AND (
token = 'cBU8PNZfSza6jKT6R5XzMkj4Aoni1aB0O9nN1aruj10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)