UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lREXbqmedZM8/4y6fReqr/6tA+nti6smHnkaV3C/OTc='
WHERE
key_id = '0c9147cda62bc3b2ce7cc11fca8605e26e0381777f899184867fc914c9d593f8'
AND (
token = 'lREXbqmedZM8/4y6fReqr/6tA+nti6smHnkaV3C/OTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)