SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '31b2e42d3e11e4371f0787ec64e66703a12fbd9793ca2b1c2ec65ec5ab50333c' 
  AND token = 'ak/Tau4lMsQtCXgc/P92q9R3EtBvp2ZB6nG9OB2Z550=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

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