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