UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'agCxZyIY1tJDGofjuQxVMRq+BA80VudpspggB9/Jjt4=' 
WHERE 
  key_id = '5c44caa6307045fb6e5b22450c81cac1d66c2d4c21051cd65c0441a9311d17de' 
  AND (
    token = 'agCxZyIY1tJDGofjuQxVMRq+BA80VudpspggB9/Jjt4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00020