UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SRSUAACEoZyrJuzTBarZRd7Y5H6nTY5RNywuXS1clRQ='
WHERE
key_id = '0b858e1dce311dadf827343a7703c95e2da548849cd9593d1357fd0ee4646de4'
AND (
token = 'SRSUAACEoZyrJuzTBarZRd7Y5H6nTY5RNywuXS1clRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)