UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FKkvL5PrvxZATr0nN0EkadZ1wzNtsTNYLbsnt7W2KCw='
WHERE
key_id = '65d54ad6b26edae57e26dc16b10b3a304fd2c0d177287d708e8ca2480e9ab7ee'
AND (
token = 'FKkvL5PrvxZATr0nN0EkadZ1wzNtsTNYLbsnt7W2KCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)