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

Query time 0.00050