UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LT31yM+EANOg+MDzjHYbkIHR+DE9tMAQj64tA+/ncss=' 
WHERE 
  key_id = '36f6f56fe1cd593d4a4ced90454ddfe28ef0a237555e50acd70ccb5090f72ca5' 
  AND (
    token = 'LT31yM+EANOg+MDzjHYbkIHR+DE9tMAQj64tA+/ncss=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028