UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'idQsEMDXxobR4k4nhi52H6l1ZOH67848d4wTohkXXOA='
WHERE
key_id = 'e2b2697159578eaceac9436da2c81ce4b6199a7480b20ae110adab49f5294ce4'
AND (
token = 'idQsEMDXxobR4k4nhi52H6l1ZOH67848d4wTohkXXOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)