UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+8KMU5Un4307crPL+0EjcfUCc0OyO7yDnkffJF+mY0g=' 
WHERE 
  key_id = '5fa644aa61f3b1c97bbc0c01a9ffb3b1f44092bc9f47068599be0b3fd2f9f828' 
  AND (
    token = '+8KMU5Un4307crPL+0EjcfUCc0OyO7yDnkffJF+mY0g=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00053