UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'XJLBFME1lCkuxxIcR9OV7MTo+War9Bfb9qjzEL04vo0=' 
WHERE 
  key_id = '5a9be20fcc9f3263f08c8321d2a8ddaff102094d292ddc0af4ed4f8a053554a0' 
  AND (
    token = 'XJLBFME1lCkuxxIcR9OV7MTo+War9Bfb9qjzEL04vo0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035