UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E9GmmEH+puTtAjzpT5sju3OQ85v+XqYizSZOIqOeBzw='
WHERE
key_id = 'a7656cf104757aae5b7efefcb0b34ae198b4505a090808f383005a7b330820df'
AND (
token = 'E9GmmEH+puTtAjzpT5sju3OQ85v+XqYizSZOIqOeBzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)