UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'riA5bM02oDcV6Iu9g3OdrVcs3WmjPYmugtfS8l8J2BA=' 
WHERE 
  key_id = '90e28223d29d19629aaf593c0470d2be4de7f8ba01fc865b8fcffbe32018c6fe' 
  AND (
    token = 'riA5bM02oDcV6Iu9g3OdrVcs3WmjPYmugtfS8l8J2BA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036