UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U/Wgmiq30Fj73eXUFmIUuk2hp6meadKoKFap2PwI5ME='
WHERE
key_id = 'c0773178614f92423cdc73f84bdad3dc0a8eeabe9d527625f3ce4ba4e06c87cc'
AND (
token = 'U/Wgmiq30Fj73eXUFmIUuk2hp6meadKoKFap2PwI5ME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)