SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6ba66371e885b14ddbb69034d7aa6b5f9438d8f7fe6f7dc29193f6029950c571' 
  AND token = 'eAaO94OC9a25rZUsCm1btK8+YzZN+x4XcLUYNkQrPuU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00041

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}