UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'W8F1EMQTjb+ZgPuLL0C5V2wP6y7f8A6aL0A+VFHJlBw=' 
WHERE 
  key_id = '569f3e38bb3f9ad17eb93ca7c4e79bf19650935b83eef52fe4f1dec91734c6b1' 
  AND (
    token = 'W8F1EMQTjb+ZgPuLL0C5V2wP6y7f8A6aL0A+VFHJlBw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035