UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'asyye7C0mSzCKHZZzs2+bMsTbiIE0yVuOZ5EXhincFQ=' 
WHERE 
  key_id = 'e3cea57849a361d6295d803272f3ed67b582b31fcf0d357ead283c83a3531148' 
  AND (
    token = 'asyye7C0mSzCKHZZzs2+bMsTbiIE0yVuOZ5EXhincFQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034