UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qnQ8Rf00WItMM14O18xrlUs92M6l1nXjU8/ieQW+4V8='
WHERE
key_id = 'be11b4dfa10421d0c712abf5b49615f19135df2c52c840b9ddcc0361250b1ed3'
AND (
token = 'qnQ8Rf00WItMM14O18xrlUs92M6l1nXjU8/ieQW+4V8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)