UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yNeBZf9INXyYOqBRdqMCBqHypgbUTtO7iBQ4kEDT/mA='
WHERE
key_id = 'bd27cf96e51aa1407c8bd2468538e69bfdb920ce2c378ab8256b3bc7fe252ffb'
AND (
token = 'yNeBZf9INXyYOqBRdqMCBqHypgbUTtO7iBQ4kEDT/mA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)