SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '55b85caaf90f8bae4db6a60dd0dd75e6e2380046897aadd5d4a98b4e07f16083' 
  AND token = 'ZVDaYx0AyBjX4ymX89toIHaNhf7c1HhgSH4Ias86fSQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}