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