UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7G0K4BTPbtglfjE5M8/TUkjOr2klRwZq7djuBUGUlM='
WHERE
key_id = '7aa9385bf3a0f795783c63e5091bf104173c39778ebf1a575bd307800ea377a9'
AND (
token = 'X7G0K4BTPbtglfjE5M8/TUkjOr2klRwZq7djuBUGUlM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)