UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnepzOcXdQWbmWwJgKrqKVzJpSpXuvriLcYN65MwP6U='
WHERE
key_id = '4f845bbae40d5b3ff61d07c4990043d6b1df34be80c81bfee32306815b6778fa'
AND (
token = 'NnepzOcXdQWbmWwJgKrqKVzJpSpXuvriLcYN65MwP6U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)