SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'addde86fea6fc7e1861a0e32031c1aea0b891b7c727cb054bbc52a5a7e86ee76' 
  AND token = 'dcrRmB5bzlKgdq1cq4fVV+rdS4T7sAgcM9wM8XS+oe8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00030

JSON explain

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