UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'kjAjXQn3W6bkcj3pEkE8Ed7si7QahLteNVSL7Sg3YUE=' 
WHERE 
  key_id = 'bbfbb0a080574f34c15d8c9b13c7b2db00b045cbcba446e3d8e9d587f237a184' 
  AND (
    token = 'kjAjXQn3W6bkcj3pEkE8Ed7si7QahLteNVSL7Sg3YUE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029