UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pQ7PsdvrIo6sSaWI4SkiklIveinBdEH/LT8LFrGghfo='
WHERE
key_id = 'fcb5eb9afdc47c6eb407ecea97a1d3e069a7c911204906f4d1afd8118bca45ac'
AND (
token = 'pQ7PsdvrIo6sSaWI4SkiklIveinBdEH/LT8LFrGghfo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)