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