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