UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'myS2u8y/YoY1hOG6pztp+ClAeuzYeOW6EGw+x+qZmHA='
WHERE
key_id = '8030ca95f55c1de53ebbbf904fd1755ec519d3df4972548e484bc3e99d273433'
AND (
token = 'myS2u8y/YoY1hOG6pztp+ClAeuzYeOW6EGw+x+qZmHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)