UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xtHNyLsr1ByXVUrKW9hdmMCxtR0p8EjgZor7udQAPhk='
WHERE
key_id = '5f1f0745e98c49f441332f117df387bee4f8ffb5c25bd6a3e9f52ef1e2a4b0fa'
AND (
token = 'xtHNyLsr1ByXVUrKW9hdmMCxtR0p8EjgZor7udQAPhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)