UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W+tqI31nr0ECNimvOFviuB/g1Y1rfQEax82vIoDVRBE='
WHERE
key_id = 'efd23a4ecf95643936853ee388ad5bec4d0811e85e19d7e0a9bd45a2cfefc2ee'
AND (
token = 'W+tqI31nr0ECNimvOFviuB/g1Y1rfQEax82vIoDVRBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)