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