SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5bef7cb28bd5d86eaa51894bdc0304d58a8858ec6927cd0cf792dbf66cc30c7c' 
  AND token = '0aFCU7m6Q3ks9XgUc3mufk+qCzoa3aGQBcoPEzn4HgU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00034

JSON explain

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