UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'r9NSg2pJAHyu7Zar85RzwlQmQ2VzgE+sJrZohSC7CD0=' 
WHERE 
  key_id = '958cb7762e4f7b109e7ee4785434b660948766fc2f89ca4d80a0c3c2d5f5827e' 
  AND (
    token = 'r9NSg2pJAHyu7Zar85RzwlQmQ2VzgE+sJrZohSC7CD0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036