UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CJ7nfNW20i7//vuyS9aCl0cS5wTR746VlJD8It28qWU='
WHERE
key_id = '7f6fd01ec7572da9e9a48fe1167aa77d3e9034ecf75cf016c0752d05c18b6e08'
AND (
token = 'CJ7nfNW20i7//vuyS9aCl0cS5wTR746VlJD8It28qWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)