UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KzvXQvxPHSLpeWweCN7ntBCzTSaxKPzF+CDNlz3pNqo='
WHERE
key_id = '917302411535ad7fc0d619429f40455d92b9c49baf4ab3f14740bae7a910755f'
AND (
token = 'KzvXQvxPHSLpeWweCN7ntBCzTSaxKPzF+CDNlz3pNqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)