SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '07092e24e269acfbaf43133b2f1d48c492a8c1f4a52208c39c2e9295053b7a75' 
  AND token = 'Tq/R6Dqpy+eXA+Mm5UDuFU3E1uPThRkb7QzsaZjfKXs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00026

JSON explain

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