UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6hM29LKZztYScIPBI/zMC2I0fcdSVw5ufLPV9tmqV3w='
WHERE
key_id = '88bfbbcdfa0c6b3405615b88f1c66baf9159fb28e7af217c48d9179ea24f0160'
AND (
token = '6hM29LKZztYScIPBI/zMC2I0fcdSVw5ufLPV9tmqV3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)