UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KS7MtDgas41DBoqf+iyhnMyYYfw8QpppBzwgh2d9lyc='
WHERE
key_id = 'a5a0a924d5449be426c9726365359ad20419e022811ae89c337c28300429d8c2'
AND (
token = 'KS7MtDgas41DBoqf+iyhnMyYYfw8QpppBzwgh2d9lyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)