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